<?php
/***********************************************************************/

// Some info about your mod.
$mod_title      = 'Lawl';
$mod_version    = '1.1.1 +';
$release_date   = '2008-04-23';
$author         = 'Fabien Appert';
$author_email   = 'markgore321@msn.com';

// Versions of PunBB this mod was created for.
$punbb_versions	= array('1.2', '1.2.1', '1.2.2', '1.2.3', '1.2.4', '1.2.5', '1.2.6', '1.2.7', '1.2.8', '1.2.9', '1.2.10', '1.2.11', '1.2.12', '1.2.13', '1.2.14');

// Set this to false if you haven't implemented the restore function (see below)
$mod_restore	= true;

// This following function will be called when the user presses the "Install" button
function install()
{
	global $db, $db_type, $pun_config;

	switch ($db_type)
	{
		case 'mysql':
		case 'mysqli':
			//ALTER TABLE `template_subscriptions` ADD `forum_id` INT( 10 ) DEFAULT '0' NOT NULL ;
			$db->query("ALTER TABLE ".$db->prefix."subscriptions ADD `forum_id` int ( 10 ) UNSIGNED  DEFAULT '0' NOT NULL") or error('Unable to alter the forums table', __FILE__, __LINE__, $db->error());
			//ALTER TABLE `template_subscriptions` DROP PRIMARY KEY, ADD PRIMARY KEY (`user_id`,`topic_id`,`forum_id`)
			$db->query("ALTER TABLE ".$db->prefix."subscriptions DROP PRIMARY KEY, ADD PRIMARY KEY (`user_id`,`topic_id`,`forum_id`)") or error('Unable to alter the forums table', __FILE__, __LINE__, $db->error());
			break;

		default:
			$db->query("ALTER TABLE ".$db->prefix."subscriptions ADD `forum_id` int ( 10 ) UNSIGNED  DEFAULT '0' NOT NULL") or error('Unable to alter the forums table', __FILE__, __LINE__, $db->error());
			$db->query("ALTER TABLE ".$db->prefix."subscriptions DROP PRIMARY KEY, ADD PRIMARY KEY (`user_id`,`topic_id`,`forum_id`)") or error('Unable to alter the forums table', __FILE__, __LINE__, $db->error());
			break;
	}
}

// This following function will be called when the user presses the "Restore" button (only if $mod_uninstall is true (see above))
function restore()
{
	global $db, $db_type, $pun_config;


//	DO DATABASE RESTORE HERE

	switch ($db_type)
	{
		default:
			//ALTER TABLE `template_subscriptions` DROP `forum_id` 
			$db->query("ALTER TABLE ".$db->prefix."subscriptions DROP forum_id") or error('Unable to drop column "$subscribed groups" from table "forums"', __FILE__, __LINE__, $db->error());
			break;
	}

}

/***********************************************************************/

// DO NOT EDIT ANYTHING BELOW THIS LINE!


// Circumvent maintenance mode
define('PUN_TURN_OFF_MAINT', 1);
define('PUN_ROOT', './');
require PUN_ROOT.'include/common.php';

// We want the complete error message if the script fails
if (!defined('PUN_DEBUG'))
	define('PUN_DEBUG', 1);

// Make sure we are running a PunBB version that this mod works with
$version_warning = false;
if(!in_array($pun_config['o_cur_version'], $punbb_versions))
{
	foreach ($punbb_versions as $temp)
	{
		if (substr($temp, 0, 3) == substr($pun_config['o_cur_version'], 0, 3))
		{
			$version_warning = true;
			break;
		}
	}

	if (!$version_warning)
		exit('You are running a version of PunBB ('.$pun_config['o_cur_version'].') that this mod does not support. This mod supports PunBB versions: '.implode(', ', $punbb_versions));
}


$style = (isset($cur_user)) ? $cur_user['style'] : $pun_config['o_default_style'];

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title><?php echo $mod_title ?> installation</title>
<link rel="stylesheet" type="text/css" href="style/<?php echo $pun_config['o_default_style'].'.css' ?>" />
</head>
<body>

<div id="punwrap">
<div id="puninstall" class="pun" style="margin: 10% 20% auto 20%">

<?php

if (isset($_POST['form_sent']))
{
	if (isset($_POST['install']))
	{
		// Run the install function (defined above)
		install();

?>
<div class="block">
	<h2><span>Installation successful</span></h2>
	<div class="box">
		<div class="inbox">
			<p>Your database has been successfully prepared for <?php echo pun_htmlspecialchars($mod_title) ?>. See readme.txt for further instructions.</p>
		</div>
	</div>
</div>
<?php

	}
	else
	{
		// Run the restore function (defined above)
		restore();

?>
<div class="block">
	<h2><span>Restore successful</span></h2>
	<div class="box">
		<div class="inbox">
			<p>Your database has been successfully restored.</p>
		</div>
	</div>
</div>
<?php

	}
}
else
{

?>
<div class="blockform">
	<h2><span>Mod installation</span></h2>
	<div class="box">
		<form method="post" action="<?php echo $_SERVER['PHP_SELF'] ?>?foo=bar">
			<div><input type="hidden" name="form_sent" value="1" /></div>
			<div class="inform">
				<p>This script will update your database to work with the following modification:</p>
				<p><strong>Mod title:</strong> <?php echo pun_htmlspecialchars($mod_title).' '.$mod_version ?></p>
				<p><strong>Author:</strong> <?php echo pun_htmlspecialchars($author) ?> (<a href="mailto:<?php echo pun_htmlspecialchars($author_email) ?>"><?php echo pun_htmlspecialchars($author_email) ?></a>)</p>
				<p><strong>Disclaimer:</strong> Mods are not officially supported by PunBB. Mods generally can't be uninstalled without running SQL queries manually against the database. Make backups of all data you deem necessary before installing.</p>
<?php if ($mod_restore): ?>				<p>If you've previously installed this mod and would like to uninstall it, you can click the restore button below to restore the database.</p>
<?php endif; ?><?php if ($version_warning): ?>				<p style="color: #a00"><strong>Warning:</strong> The mod you are about to install was not made specifically to support your current version of PunBB (<?php echo $pun_config['o_cur_version']; ?>). However, in most cases this is not a problem and the mod will most likely work with your version as well. If you are uncertain about installning the mod due to this potential version conflict, contact the mod author.</p>
<?php endif; ?>			</div>
			<p><input type="submit" name="install" value="Install" /><?php if ($mod_restore): ?><input type="submit" name="restore" value="Restore" /><?php endif; ?></p>
		</form>
	</div>
</div>
<?php

}

?>

</div>
</div>

</body>
</html>